<?php
namespace Api\Controller\V2;
use Think\Controller;

class ProductController extends CommonController {
    public function index(){
        header("Content-type:text/html;charset=utf8;");
        echo "众测天下";
    }
    
    /*
     * 产品查询 by 条形码
     * 通过条形码，先去本地的数据库找一下
     */
    public function get_info_by_barcode() {
        $barcode = I('get.barcode');
        $mid = I('get.mid');
        
        $DB = M('product');
        $map['barcode']=$barcode;
        
        $res = $DB->where($map)->find();
        
        if(!empty($res))
        {
            $relative_foundings = $this->get_product_foundings($res['id']);
            if(!empty($relative_foundings))
            {
                $res['item_count']= count($relative_foundings);
                $res['items']= ($relative_foundings);
            }
            else
            {
                $res['item_count']= 0;
                $res['items']=array();
            }
            
            $res['items']= ($relative_foundings);
            $this->json_output($res);
            
        }
        else
        {
            $ress = $this->get_info_product_yiyuan($barcode);
            if(!empty($ress)){
               
                $this->json_output($ress);
            }
            else
            {
                $data=array();
                $this->json_output($data,'ok','第三方API无输出');
            }
            
        }
        
        
    }
    
    /*
     * 批量检查数据
     */
    public function multi_check_barcodes() {
        $DB = M("tmp_data2");
        
        $res = $DB->select();
//        print_r($res);
        foreach ($res as $key => $value) {
            $this->get_info_by_barcode_one($value['barcode']);
        }
    }

    
    public function get_info_by_barcode_one($barcode) {
//        $barcode = I('get.barcode');
        
        $DB = M('product');
        $map['barcode']=$barcode;
        
        $res = $DB->where($map)->find();
        
        if(!empty($res))
        {

            
        }
        else
        {
            $ress = $this->get_info_product_yiyuan_twice($barcode);
            if(!empty($ress)){
               
//                有数据则删除记录
                $map_del['barcode'] = $barcode;
                $DB = M("tmp_data2");
                $DB->where($map_del)->delete();
                
            }
            else
            {
                echo $barcode."<br/>";
                
                
            }
            
        }
        
        
    }
    
    
    /*
     * 新增一个来测试第三方库的丰富度
     */
    public function get_info_by_barcode_new_test() {
        $barcode = I('get.barcode');
        $mid = I('get.mid');
        
        $DB = M('product_copy');
        $map['barcode']=$barcode;
        
        $res = $DB->where($map)->find();
        
        if(!empty($res))
        {
            $relative_foundings = $this->get_product_foundings($res['id']);
            if(!empty($relative_foundings))
            {
                $res['item_count']= count($relative_foundings);
                $res['items']= ($relative_foundings);
            }
            else
            {
                $res['item_count']= 0;
                $res['items']=array();
            }
            
            $res['items']= ($relative_foundings);
            $this->json_output($res);
            
        }
        else
        {
            $ress = $this->get_info_product_yiyuan($barcode);
            if(!empty($ress)){
               
                $this->json_output($ress);
            }
            else
            {
                $data=array();
                $this->json_output($data,'ok','易源API无输出');
            }
            
        }
        
        
    }
    
    public function get_info_by_barcode_from_android() {
        $barcode = I('get.barcode');
        $mid = I('get.mid');
        
        $DB = M('product');
        $map['barcode']=$barcode;
        
        $res = $DB->where($map)->find();
        
        if(!empty($res))
        {
            $relative_foundings = $this->get_product_foundings($res['id']);
            if(!empty($relative_foundings))
            {
                $res['item_count']= count($relative_foundings);
                $res['items']= ($relative_foundings);
            }
            else
            {
                $res['item_count']= 0;
                $res['items']=array();
            }
            
            $res['items']= ($relative_foundings);
            $this->json_output($res);
            
        }
        else
        {
            $ress = $this->get_info_product_yiyuan($barcode);
            if(!empty($ress)){
               
                $this->json_output($ress);
            }
            else
            {
                $res['err']=0;
                $res['msg']='暂无数据(server)';
                $res['count']=0;
                $res['content']='';
                
            echo json_encode($res);
//                $data="";
//                $this->json_output($data,'ok','聚合API无输出');
            }
            
        }
        
        
    }

    // public function ceshi(){

    //     $barcode = I('get.barcode');
    //     $res = $this->get_info_product_juhe($barcode);

    //     print_r($res);
    // }

    //从远程聚合数据获取到条形码产品数据
    private function get_info_product_juhe($barcode){
        //包名
        $pkg = 'com.mdkkj.zhongcetianxia';
        //appkey
        $appkey = '71588de5d4c2b919a8fd432d39912317';
        //拼接聚合get请求链接
        $url = 'http://api.juheapi.com/jhbar/bar?appkey='.$appkey.'&pkg='.$pkg.'&barcode='.$barcode.'&cityid=1';

        $list = file_get_contents($url);
        //将list由返回的json格式转换为数组;
        $list = json_decode($list,true);

        if($list['error_code']==0){

            $data['name'] = $list['result']['summary']['name'];
//            $data['pjname'] = $list['result']['summary']['name'];
            $data['imgurl'] = $list['result']['summary']['imgurl'];
            $data['barcode'] = $list['result']['summary']['barcode'];
            $data['ctime'] = I('server.REQUEST_TIME');

            $id = M('product')->data($data)->add();

            if(!empty($id)){

                $res = M('product')->find($id);
                $res['item_count']= 0;
                $res['items']=array();

            }else{

                return false;
            }

            return $res;

        }else{

            return false;
        }
    }
    
    //通过 易源 API 来获取数据
    private function get_info_product_yiyuan($barcode){
        //包名
        $pkg = 'com.mdkkj.zhongcetianxia';
        //appkey 
       $appkey = '71588de5d4c2b919a8fd432d39912317';
        //拼接聚合get请求链接
//        $url = 'http://api.juheapi.com/jhbar/bar?appkey='.$appkey.'&pkg='.$pkg.'&barcode='.$barcode.'&cityid=1';
        
        $timestamp = date("YmdHis",I("server.REQUEST_TIME"));
        
        $url = "http://route.showapi.com/66-22?code=$barcode&showapi_appid=12020&showapi_timestamp=$timestamp&showapi_sign=ff003a5c3fb3411c9ad3839365b5df49";
//        print_r($url);
        $list = file_get_contents($url);
//        print_r($list);
        //将list由返回的json格式转换为数组;
        $list = json_decode($list,true);
//        print_r($list);
        
        if($list['showapi_res_code']==0)
        {
            $data['name'] = $list['showapi_res_body']['goodsName'];
//            $data['pjname'] = $list['showapi_res_body']['goodsName'];
            $data['imgurl'] = $list['showapi_res_body']['img'];
            $data['barcode'] = $barcode;
            $data['ctime'] = I('server.REQUEST_TIME');

            $id = M('product')->data($data)->add();

            if(!empty($id)){

                $res = M('product')->find($id);
                $res['item_count']= 0;
                $res['items']=array();

            }else{

                return $this->get_info_product_yiyuan_twice($barcode);
            }

            return $res;
        }
        else
        {
            return $this->get_info_product_yiyuan_twice($barcode);
        }
    }
    
    private function get_info_product_yiyuan_twice($barcode){
        //包名
        $pkg = 'com.mdkkj.zhongcetianxia';
        //appkey 
       $appkey = '71588de5d4c2b919a8fd432d39912317';
        //拼接聚合get请求链接
//        $url = 'http://api.juheapi.com/jhbar/bar?appkey='.$appkey.'&pkg='.$pkg.'&barcode='.$barcode.'&cityid=1';
        
        $timestamp = date("YmdHis",I("server.REQUEST_TIME"));
        
        $url = "http://route.showapi.com/66-22?code=$barcode&showapi_appid=12020&showapi_timestamp=$timestamp&showapi_sign=ff003a5c3fb3411c9ad3839365b5df49";
//        print_r($url);
        $list = file_get_contents($url);
//        print_r($list);
        //将list由返回的json格式转换为数组;
        $list = json_decode($list,true);
//        print_r($list);
        
        if($list['showapi_res_code']==0)
        {
            $data['name'] = $list['showapi_res_body']['goodsName'];
//            $data['pjname'] = $list['showapi_res_body']['goodsName'];
            $data['imgurl'] = $list['showapi_res_body']['img'];
            $data['barcode'] = $barcode;
            $data['ctime'] = I('server.REQUEST_TIME');

            $id = M('product')->data($data)->add();

            if(!empty($id)){

                $res = M('product')->find($id);
                $res['item_count']= 0;
                $res['items']=array();

            }else{

                return false;
            }

            return $res;
        }
        else
        {
            return false;
        }
    }
    
    public function get_info_product_yiyuan_2(){

        $barcode = I('get.barcode');
        $timestamp = date("YmdHis",I("server.REQUEST_TIME"));
        
        $url = "http://route.showapi.com/66-22?code=$barcode&showapi_appid=12020&showapi_timestamp=$timestamp&showapi_sign=ff003a5c3fb3411c9ad3839365b5df49";
//        print_r($url);
        $list = file_get_contents($url);
        print_r($list);
//        //将list由返回的json格式转换为数组;
//        $list = json_decode($list,true);
//        print_r($list);
        


//        
    }
    
    
    /*
     * 产品查询 by 关键字，得到一个list
     */
    public function get_info_by_keywords() {
        $mid = I('get.mid');
        $keywords = trim(I('get.keywords'));
        
        if(empty($keywords))
        {
            $DB = M('fundings');
//            $map['pdname']=array('like',"%$keywords%");
            //过滤掉未审核的和未支付的订单
            $map['state']=array(array('neq',0),array('neq',4));

            $res = $DB->where($map)->order("result DESC,state DESC,ctime DESC")->limit(30)->select();
            foreach ($res as $key => $value) {
                $res[$key]['name']=$value['pjname'];
                $res[$key]['pjname']=$value['pjname'];
                $res[$key]['isurl']= 0;
                $res[$key]['url']= "";
                $res[$key]['qualified']= 0;
                $res[$key]['testing_date']= date("Y-m-d",$value['ctime']);
                $res[$key]['batch_number']= $value['batch'];
                $res[$key]['batch']= $value['batch'];
                $res[$key]['packagename']= $this->get_name_by_packageid($value['packageid']);
                $res[$key]['emoney']=($value['emoney']+$value['smoney']*$value['samnum']);
                $res[$key]['testing_result']=$this->_get_testing_report_short_analyze($value['testreportid']);
            }          
            $count_res = count($res);

            if(!empty($res))
            {
                $this->json_output($res);
            }
            else
            {
                $res = $this->_get_defualt_data();
                $this->json_output($res);
//                $this->json_output(0);
            }
        }
        else
        {
            $keywords_py  = trim(I('get.keywords_py'));
            $DB = M('fundings');
            $map['pdname']=array('like',"%$keywords%");
            //过滤掉未审核的和未支付的订单
            $map['state']=array('neq',0);

            $res = $DB->where($map)->order("ctime DESC,state DESC,result DESC")->select();
            foreach ($res as $key => $value) {
                $res[$key]['name']=$value['pjname'];
                $res[$key]['pjname']=$value['pjname'];
                $res[$key]['isurl']= 0;
                $res[$key]['url']= "";
                $res[$key]['qualified']= 0;
                $res[$key]['testing_date']= date("Y-m-d",$value['ctime']);
                $res[$key]['batch_number']= $value['batch'];
                $res[$key]['batch']= $value['batch'];
                $res[$key]['packagename']= $this->get_name_by_packageid($value['packageid']);
                $res[$key]['emoney']=($value['emoney']+$value['smoney']*$value['samnum']);
                $res[$key]['testing_result']=$this->_get_testing_report_short_analyze($value['testreportid']);
            }          
            $count_res = count($res);

            $res_thirdparty = $this->get_thirdparty_product_by_name($keywords_py,$keywords,0,20);

            if($res_thirdparty)
            {
                foreach ($res_thirdparty as $key => $value) {
                    $res[$count_res+$key]['name'] = $value['product_name'];
                    $res[$count_res+$key]['pjname'] = $value['product_name'];
                    $res[$count_res+$key]['id'] = 0;
                    $res[$count_res+$key]['isurl']= 1;
                    $res[$count_res+$key]['url']= C('product_domain').U('M/Founding/show_thirdparty_data_of_app',array('id'=>$value['id']));
                    $res[$count_res+$key]['qualified']= (int)$value['qualified'];
                    $res[$count_res+$key]['location']= $value['province'];
                    $res[$count_res+$key]['testing_date']= $value['notification_number'];
                    $res[$count_res+$key]['batch_number']= $value['cdate'];
                    $res[$count_res+$key]['batch']= $value['cdate'];
//                    $res[$count_res+$key]['testing_result']="";
                    $testing_result = explode("║", $value['unqualified_remark']);
                    
                    $res[$count_res+$key]['testing_result']=$testing_result[0]." 超标";
                }
            }
            
            
            if(!empty($res))
            {
                $this->json_output($res,"ok","err");
            }
            else
            {
                $more_data['recommend_data'] = $this->_get_recommend_data($keywords, $keywords_py, 0);
                $this->json_output(0,"ok","err",$more_data);
            }
        }
        
    }
    
    /*
     * 分页数据
     */
    public function get_info_by_keywords_with_page() {
        
        $mid = I('get.mid');
        $keywords = trim(I('get.keywords'));
        
        if(empty($keywords))
        {
            $keywords_py  = trim(I('get.keywords_py'));
        
            $pagecount = I('get.pagecount');
            if(empty($pagecount))
            {
                $pagecount=0;
            }

            $startposition = ($pagecount)*10;

            $res_thirdparty = $this->get_thirdparty_product_by_name($keywords_py,$keywords,$startposition,10);

            if($res_thirdparty)
            {
                foreach ($res_thirdparty as $key => $value) {
                    $res[$key]['name'] = $value['product_name'];
                    $res[$key]['pjname'] = $value['product_name'];
                    $res[$key]['id'] = 0;
                    $res[$key]['isurl']= 1;
                    $res[$key]['url']= C('product_domain').U('M/Founding/show_thirdparty_data_of_app',array('id'=>$value['id']));
                    $res[$key]['qualified']= (int)$value['qualified'];
                    $res[$key]['location']= $value['province'];
                    $res[$key]['testing_date']= $value['notification_number'];
                    $res[$key]['batch_number']= $value['cdate'];
                    $res[$key]['batch']= $value['cdate'];
                    $res[$key]['emoney']=($value['emoney']+$value['smoney']*$value['samnum']);
                    $testing_result = explode("║", $value['unqualified_remark']);
                    
                    $res[$key]['testing_result']=$testing_result[0]." 超标";
                }
            }
            if(!empty($res))
            {
                $this->json_output($res);
            }
            else
            {
                $more_data['recommend_data'] = $this->_get_recommend_data($keywords, $keywords_py, 0);
                $this->json_output(0,"ok","err",$more_data);
//                $this->json_output(0);
            }
        }
        else
        {
            $keywords_py  = trim(I('get.keywords_py'));
        
            $pagecount = I('get.pagecount');
            if(empty($pagecount))
            {
                $pagecount=0;
            }

            $startposition = ($pagecount)*10;

            $res_thirdparty = $this->get_thirdparty_product_by_name($keywords_py,$keywords,$startposition,10);

            if($res_thirdparty)
            {
                foreach ($res_thirdparty as $key => $value) {
                    $res[$key]['name'] = $value['product_name'];
                    $res[$key]['pjname'] = $value['product_name'];
                    $res[$key]['id'] = 0;
                    $res[$key]['isurl']= 1;
                    $res[$key]['url']= C('product_domain').U('M/Founding/show_thirdparty_data_of_app',array('id'=>$value['id']));
                    $res[$key]['qualified']= (int)$value['qualified'];
                    $res[$key]['location']= $value['province'];
                    $res[$key]['testing_date']= $value['notification_number'];
                    $res[$key]['batch_number']= $value['cdate'];
                    $res[$key]['batch']= $value['cdate'];
                    $testing_result = explode("║", $value['unqualified_remark']);
                    
                    $res[$key]['testing_result']=$testing_result[0]." 超标";
                }
            }
            if(!empty($res))
            {
                $this->json_output($res);
            }
            else
            {
                $more_data['recommend_data'] = $this->_get_recommend_data($keywords, $keywords_py, 0);
                $this->json_output(0,"ok","err",$more_data);
//                $this->json_output(0);
            }
        }
        
    }
    
    
    /*
     * 产品查询 by id
     */
    public function get_info_by_pid() {
        $pid = I('get.pid');
        $mid = I('get.mid');
        
        $DB = M('product');
        
        $res = $DB->find($pid);
        
        if(!empty($res))
        {
            $relative_foundings = $this->get_product_foundings($res['id']);
            if(!empty($relative_foundings))
            {
                $res['item_count']= count($relative_foundings);
                $res['items']= ($relative_foundings);
            }
            else
            {
                $res['item_count']= 0;
                $res['items']= array();
            }   
            
            
            $this->json_output($res);
        }
        else
        {
            $this->json_output(0);
        }
    }
    
    /*
     * 没有数据的查询
     * 
     */
    public function _get_defualt_data() {
            $DB = M('fundings');
//            $map['pdname']=array('like',"%$keywords%");
            //过滤掉未审核的和未支付的订单
            $map['state']=array("eq",3);

            $res = $DB->where($map)->order("result DESC,state DESC,ctime DESC")->limit(30)->select();
            foreach ($res as $key => $value) {
                $res[$key]['name']=$value['pjname'];
                $res[$key]['pjname']=$value['pjname'];
                $res[$key]['isurl']= 0;
                $res[$key]['url']= "";
                $res[$key]['qualified']= 0;
                $res[$key]['testing_date']= date("Y-m-d",$value['ctime']);
                $res[$key]['batch_number']= $value['batch'];
                $res[$key]['batch']= $value['batch'];
                $res[$key]['packagename']= $this->get_name_by_packageid($value['packageid']);
                $res[$key]['emoney']=($value['emoney']+$value['smoney']*$value['samnum']);
                $res[$key]['testing_result']=$this->_get_testing_report_short_analyze($value['testreportid']);
            }
            
            return $res;
    }
    
    
    /*
     * 找出该产品是否有对应的检测项目
     */
    
    private function get_product_foundings($pid) {
        $DB= M('fundings');
        
        $map['pid']=$pid;
        $res = $DB->where($map)->select();
        if(!empty($res))
        {
            return $res;
        }
        else
        {
            return 0;
        }
        
    }
    
    /*
     * 找出关键字产品在第三方抓取的数据库里边的匹配数据
     */
    private function get_thirdparty_product_by_name($keywords_py,$keywords,$offset,$number) {
        
//        if($type==1)
//        {
//            $DB = M('product_thirdparty');
//        
//            $map['product_name'] = array('like',"%$name%");
//
//            $res = $DB->where($map)->select();
//        }
//        else
//        {
        if(empty($keywords))
        {
            $Model = new \Think\Model();
            $res = $Model->query("select * from fd_product_thirdparty order by id DESC limit $offset,$number");
        }
        else
        {
            $keywords_pys = str_replace(',', ' +', $keywords_py);
            $keywords_pys ='+'.$keywords_pys;
            $Model = new \Think\Model();
            $res = $Model->query("select * from fd_product_thirdparty where product_name LIKE '%".$keywords."%' AND match(product_name_pinyin) against('".$keywords_pys."' IN BOOLEAN MODE) order by qualified limit $offset,$number");
        }
            
            
//        }
        
        if(!empty($res))
        {
            return $res;
        }
        else {
            return FALSE;
        }   
    }
    
    public function testsearch() {
//        $DB = M('product_thirdparty');
//        select * from song where match(singername) against('周杰伦') ;
        $words = trim(I('get.words'));
        $Model = new \Think\Model();
        $res = $Model->query("select * from fd_product_thirdparty where match(product_name_pinyin) against('".$words."')");
        print_r($res);
        
        $name="猪肉";
        $DB = M('product_thirdparty');
        
        $map['product_name'] = array('like',"%$name%");

        $ress = $DB->where($map)->select();
        
        print_r($ress);
        
    }
    
    /*
     * 获取搜索关键字(正常搜索和曝光台）
     * type =0 正常搜索页面
     * type=1 曝光台
     */
    public function get_search_keywords() {
        $mid = I("get.mid");
        $type=I('get.type');
        if(empty($type))
        {
            $type=0;
        }
         $DB_search_tags = M('search_tags');
        $map['type'] = $type;
        $list = $DB_search_tags->where($map)->order("rank DESC")->select();
        
        $this->json_output($list);
    }




    /**
    曝光台产品查询接口
    **/
    //通过关键字查询不合格产品
    public function get_unsafe_info_by_keywords() {
        $mid = I('get.mid');
        $pagecount = I('get.pagecount');
        if(!empty($pagecount)){

            $pagecount = $pagecount*10;
        }else{

            $pagecount = 0;
        }
        $keywords = trim(I('get.keywords'));
        
        if(empty($keywords))
        {
            $keywords_py  = trim(I('get.keywords_py'));
            $DB = M('fundings');
            $map['pdname']=array('like',"%$keywords%");
            $map['result'] = 2;
            $map['state'] = 3;
            $res = $DB->where($map)->order('ctime DESC')->limit($pagecount,10)->select();
            foreach ($res as $key => $value) {
                $res[$key]['name']=$value['pjname'];
                $res[$key]['pjname']=$value['pjname'];
                $res[$key]['isurl']= 0;
                $res[$key]['url']= "";
                // $res[$key]['qualified']= 0;
                $res[$key]['testing_date']= date("Y-m-d",$value['ctime']);
                $res[$key]['batch_number']= $value['batch'];
                $res[$key]['batch']= $value['batch'];
                $res[$key]['packagename']= $this->get_name_by_packageid($value['packageid']);
                $res[$key]['testing_result']=$this->_get_testing_report_short_analyze($value['testreportid']);
            }          
            $count_res = count($res);
            
            $res_thirdparty = $this->get_unsafe_thirdparty_product_by_name("","",$pagecount);
            // echo json_output($res_thirdparty); die;
            if($res_thirdparty)
            {
                foreach ($res_thirdparty as $key => $value) {
                    $res[$count_res+$key]['name'] = $value['product_name'];
                    $res[$count_res+$key]['pjname'] = $value['product_name'];
                    $res[$count_res+$key]['id'] = 0;
                    $res[$count_res+$key]['isurl']= 1;
                    $res[$count_res+$key]['url']= C('product_domain').U('M/Founding/show_thirdparty_data_of_app',array('id'=>$value['id']));
                    // $res[$count_res+$key]['qualified']= (int)$value['qualified'];
                    $res[$count_res+$key]['location']= $value['province'];
                    $res[$count_res+$key]['testing_date']= $value['notification_number'];
                    $res[$count_res+$key]['batch_number']= $value['cdate'];
                    $res[$count_res+$key]['batch']= $value['cdate'];
                    $testing_result = explode("║", $value['unqualified_remark']);
                    
                    $res[$count_res+$key]['testing_result']=$testing_result[0]." 超标";
                }
            }
            if(!empty($res))
            {
                $this->json_output($res);
            }
            else
            {
                $this->json_output(0);
            }
        }
        else
        {
            $keywords_py  = trim(I('get.keywords_py'));
            $DB = M('fundings');
            $map['pdname']=array('like',"%$keywords%");
            $map['result'] = 2;
            $map['state'] = 3;
            $res = $DB->where($map)->order('ctime DESC')->limit($pagecount,10)->select();
            foreach ($res as $key => $value) {
                $res[$key]['name']=$value['pjname'];
                $res[$key]['pjname']=$value['pjname'];
                $res[$key]['isurl']= 0;
                $res[$key]['url']= "";
                // $res[$key]['qualified']= 0;
                $res[$key]['testing_date']= date("Y-m-d",$value['ctime']);
                $res[$key]['batch_number']= $value['batch'];
                $res[$key]['batch']= $value['batch'];
                $res[$key]['packagename']= $this->get_name_by_packageid($value['packageid']);
                $res[$key]['testing_result']=$this->_get_testing_report_short_analyze($value['testreportid']);
            }          
            $count_res = count($res);

            $res_thirdparty = $this->get_unsafe_thirdparty_product_by_name($keywords_py,$keywords,$pagecount);
            // echo json_output($res_thirdparty); die;
            if($res_thirdparty)
            {
                foreach ($res_thirdparty as $key => $value) {
                    $res[$count_res+$key]['name'] = $value['product_name'];
                    $res[$count_res+$key]['pjname'] = $value['product_name'];
                    $res[$count_res+$key]['id'] = 0;
                    $res[$count_res+$key]['isurl']= 1;
                    $res[$count_res+$key]['url']= C('product_domain').U('M/Founding/show_thirdparty_data_of_app',array('id'=>$value['id']));
                    // $res[$count_res+$key]['qualified']= (int)$value['qualified'];
                    $res[$count_res+$key]['location']= $value['province'];
                    $res[$count_res+$key]['testing_date']= $value['notification_number'];
                    $res[$count_res+$key]['batch_number']= $value['cdate'];
                    $res[$count_res+$key]['batch']= $value['cdate'];
//                    $res[$count_res+$key]['testing_result']="";
                    $testing_result = explode("║", $value['unqualified_remark']);
                    
                    $res[$count_res+$key]['testing_result']=$testing_result[0]." 超标";

                }
            }
            if(!empty($res))
            {
                $this->json_output($res);
            }
            else
            {
                $more_data['recommend_data'] = $this->_get_defualt_data();
                $this->json_output(0,"ok","err",$more_data);
//                $this->json_output(0);
            }
        }
        
    }



    /**
     * 查询第三方数据中不合格的产品
     */
    
    private function get_unsafe_thirdparty_product_by_name($keywords_py,$keywords,$pagecount) {
        
        if(empty($keywords))
        {
            $Model = new \Think\Model();
            $res = $Model->query("select * from fd_product_thirdparty where qualified=0 order by id DESC limit ".$pagecount.",10");
//             echo $Model->getLastSql();
            if(!empty($res)){

                return $res;
            }else {
                return FALSE;
            }
        }
        else
        {
            $keywords_py = str_replace(',', ' +', $keywords_py);
            $keywords_py ='+'.$keywords_py;
            $Model = new \Think\Model();
            $res = $Model->query("select * from fd_product_thirdparty where product_name LIKE '%".$keywords."%' AND qualified=0 AND match(product_name_pinyin) against('".$keywords_py."' IN BOOLEAN MODE) order by qualified limit ".$pagecount.",10");
            // echo $Model->getLastSql();
            if(!empty($res)){

                return $res;
            }else {
                return FALSE;
            }
        }
           
    }
    /*
     * 获取模糊搜索结果
     */
    private function _get_recommend_data($keywords,$keywords_py,$pagecount=0)
    {
        $pagecount = $pagecount*10;
        
        $keywords_py = str_replace(',', ' ', $keywords_py);
        $keywords_py ='+'.$keywords_py;
        $Model = new \Think\Model();
        $res = $Model->query("select * from fd_product_thirdparty where match(product_name_pinyin) against('".$keywords_py."' IN BOOLEAN MODE) order by qualified limit ".$pagecount.",10");
        foreach ($res as $key => $value) {
            $ress[$key]['name'] = $value['product_name'];
            $ress[$key]['pjname'] = $value['product_name'];
            $ress[$key]['id'] = 0;
            $ress[$key]['isurl']= 1;
            $ress[$key]['url']= C('product_domain').U('M/Founding/show_thirdparty_data_of_app',array('id'=>$value['id']));
            $ress[$key]['qualified']= (int)$value['qualified'];
            $ress[$key]['location']= $value['province'];
            $ress[$key]['testing_date']= $value['notification_number'];
            $ress[$key]['batch_number']= $value['cdate'];
            $ress[$key]['batch']= $value['cdate'];
            $res[$key]['testing_result']="";
            $testing_result = explode("║", $value['unqualified_remark']);
                    
            $res[$key]['testing_result']=$testing_result[0]." 超标";
        }

        if(!empty($ress)){

            return $ress;
        }else {
            $res = $this->_get_defualt_data();
//                $this->json_output($res);
            return $res;
        }
    }
    
    
    /*
     * 添加产品
     * 根据 APP 提交上来的数据来添加到数据库去  产品的名称、产品条码、产品品牌、
     *
     */
    public function add_product_data() {
        
        $data['barcode']=I("post.barcode");
        $data['name']=I("post.name");
        $data['brand']=I("post.brand");
        $data['ctime']=I("server.REQUEST_TIME");

        $DB = M("product");
        $id=  $DB->add($data);

        if($id)
        {
            $this->json_output($id,"ok","err");
        }
        else
        {
            $this->json_output(0,"ok","err");
        }
    }
}

class PinYin {
    private $pylist = array(
    'a'=>-20319,'ai'=>-20317,'an'=>-20304,'ang'=>-20295,'ao'=>-20292,
    'ba'=>-20283,'bai'=>-20265,'ban'=>-20257,'bang'=>-20242,'bao'=>-20230,'bei'=>-20051,'ben'=>-20036,'beng'=>-20032,'bi'=>-20026,'bian'=>-20002,'biao'=>-19990,'bie'=>-19986,'bin'=>-19982,'bing'=>-19976,'bo'=>-19805,'bu'=>-19784,
    'ca'=>-19775,'cai'=>-19774,'can'=>-19763,'cang'=>-19756,'cao'=>-19751,'ce'=>-19746,'ceng'=>-19741,'cha'=>-19739,'chai'=>-19728,'chan'=>-19725,'chang'=>-19715,'chao'=>-19540,'che'=>-19531,'chen'=>-19525,'cheng'=>-19515,'chi'=>-19500,'chong'=>-19484,'chou'=>-19479,'chu'=>-19467,'chuai'=>-19289,'chuan'=>-19288,'chuang'=>-19281,'chui'=>-19275,'chun'=>-19270,'chuo'=>-19263,'ci'=>-19261,'cong'=>-19249,'cou'=>-19243,'cu'=>-19242,'cuan'=>-19238,'cui'=>-19235,'cun'=>-19227,'cuo'=>-19224,
    'da'=>-19218,'dai'=>-19212,'dan'=>-19038,'dang'=>-19023,'dao'=>-19018,'de'=>-19006,'deng'=>-19003,'di'=>-18996,'dian'=>-18977,'diao'=>-18961,'die'=>-18952,'ding'=>-18783,'diu'=>-18774,'dong'=>-18773,'dou'=>-18763,'du'=>-18756,'duan'=>-18741,'dui'=>-18735,'dun'=>-18731,'duo'=>-18722,
    'e'=>-18710,'en'=>-18697,'er'=>-18696,
    'fa'=>-18526,'fan'=>-18518,'fang'=>-18501,'fei'=>-18490,'fen'=>-18478,'feng'=>-18463,'fo'=>-18448,'fou'=>-18447,'fu'=>-18446,
    'ga'=>-18239,'gai'=>-18237,'gan'=>-18231,'gang'=>-18220,'gao'=>-18211,'ge'=>-18201,'gei'=>-18184,'gen'=>-18183,'geng'=>-18181,'gong'=>-18012,'gou'=>-17997,'gu'=>-17988,'gua'=>-17970,'guai'=>-17964,'guan'=>-17961,'guang'=>-17950,'gui'=>-17947,
'gun'=>-17931,'guo'=>-17928,
    'ha'=>-17922,'hai'=>-17759,'han'=>-17752,'hang'=>-17733,'hao'=>-17730,'he'=>-17721,'hei'=>-17703,'hen'=>-17701,'heng'=>-17697,'hong'=>-17692,'hou'=>-17683,'hu'=>-17676,'hua'=>-17496,'huai'=>-17487,'huan'=>-17482,'huang'=>-17468,'hui'=>-17454,
'hun'=>-17433,'huo'=>-17427,
    'ji'=>-17417,'jia'=>-17202,'jian'=>-17185,'jiang'=>-16983,'jiao'=>-16970,'jie'=>-16942,'jin'=>-16915,'jing'=>-16733,'jiong'=>-16708,'jiu'=>-16706,'ju'=>-16689,'juan'=>-16664,'jue'=>-16657,'jun'=>-16647,
    'ka'=>-16474,'kai'=>-16470,'kan'=>-16465,'kang'=>-16459,'kao'=>-16452,'ke'=>-16448,'ken'=>-16433,'keng'=>-16429,'kong'=>-16427,'kou'=>-16423,'ku'=>-16419,'kua'=>-16412,'kuai'=>-16407,'kuan'=>-16403,'kuang'=>-16401,'kui'=>-16393,'kun'=>-16220,'kuo'=>-16216,
    'la'=>-16212,'lai'=>-16205,'lan'=>-16202,'lang'=>-16187,'lao'=>-16180,'le'=>-16171,'lei'=>-16169,'leng'=>-16158,'li'=>-16155,'lia'=>-15959,'lian'=>-15958,'liang'=>-15944,'liao'=>-15933,'lie'=>-15920,'lin'=>-15915,'ling'=>-15903,'liu'=>-15889,
'long'=>-15878,'lou'=>-15707,'lu'=>-15701,'lv'=>-15681,'luan'=>-15667,'lue'=>-15661,'lun'=>-15659,'luo'=>-15652,
    'ma'=>-15640,'mai'=>-15631,'man'=>-15625,'mang'=>-15454,'mao'=>-15448,'me'=>-15436,'mei'=>-15435,'men'=>-15419,'meng'=>-15416,'mi'=>-15408,'mian'=>-15394,'miao'=>-15385,'mie'=>-15377,'min'=>-15375,'ming'=>-15369,'miu'=>-15363,'mo'=>-15362,'mou'=>-15183,'mu'=>-15180,
    'na'=>-15165,'nai'=>-15158,'nan'=>-15153,'nang'=>-15150,'nao'=>-15149,'ne'=>-15144,'nei'=>-15143,'nen'=>-15141,'neng'=>-15140,'ni'=>-15139,'nian'=>-15128,'niang'=>-15121,'niao'=>-15119,'nie'=>-15117,'nin'=>-15110,'ning'=>-15109,'niu'=>-14941,
'nong'=>-14937,'nu'=>-14933,'nv'=>-14930,'nuan'=>-14929,'nue'=>-14928,'nuo'=>-14926,
    'o'=>-14922,'ou'=>-14921,
    'pa'=>-14914,'pai'=>-14908,'pan'=>-14902,'pang'=>-14894,'pao'=>-14889,'pei'=>-14882,'pen'=>-14873,'peng'=>-14871,'pi'=>-14857,'pian'=>-14678,'piao'=>-14674,'pie'=>-14670,'pin'=>-14668,'ping'=>-14663,'po'=>-14654,'pu'=>-14645,
    'qi'=>-14630,'qia'=>-14594,'qian'=>-14429,'qiang'=>-14407,'qiao'=>-14399,'qie'=>-14384,'qin'=>-14379,'qing'=>-14368,'qiong'=>-14355,'qiu'=>-14353,'qu'=>-14345,'quan'=>-14170,'que'=>-14159,'qun'=>-14151,
    'ran'=>-14149,'rang'=>-14145,'rao'=>-14140,'re'=>-14137,'ren'=>-14135,'reng'=>-14125,'ri'=>-14123,'rong'=>-14122,'rou'=>-14112,'ru'=>-14109,'ruan'=>-14099,'rui'=>-14097,'run'=>-14094,'ruo'=>-14092,
    'sa'=>-14090,'sai'=>-14087,'san'=>-14083,'sang'=>-13917,'sao'=>-13914,'se'=>-13910,'sen'=>-13907,'seng'=>-13906,'sha'=>-13905,'shai'=>-13896,'shan'=>-13894,'shang'=>-13878,'shao'=>-13870,'she'=>-13859,'shen'=>-13847,'sheng'=>-13831,'shi'=>-13658,'shou'=>-13611,'shu'=>-13601,'shua'=>-13406,'shuai'=>-13404,'shuan'=>-13400,'shuang'=>-13398,'shui'=>-13395,'shun'=>-13391,'shuo'=>-13387,'si'=>-13383,'song'=>-13367,'sou'=>-13359,'su'=>-13356,'suan'=>-13343,'sui'=>-13340,'sun'=>-13329,'suo'=>-13326,
    'ta'=>-13318,'tai'=>-13147,'tan'=>-13138,'tang'=>-13120,'tao'=>-13107,'te'=>-13096,'teng'=>-13095,'ti'=>-13091,'tian'=>-13076,'tiao'=>-13068,'tie'=>-13063,'ting'=>-13060,'tong'=>-12888,'tou'=>-12875,'tu'=>-12871,'tuan'=>-12860,'tui'=>-12858,'tun'=>-12852,'tuo'=>-12849,
    'wa'=>-12838,'wai'=>-12831,'wan'=>-12829,'wang'=>-12812,'wei'=>-12802,'wen'=>-12607,'weng'=>-12597,'wo'=>-12594,'wu'=>-12585,
    'xi'=>-12556,'xia'=>-12359,'xian'=>-12346,'xiang'=>-12320,'xiao'=>-12300,'xie'=>-12120,'xin'=>-12099,'xing'=>-12089,'xiong'=>-12074,'xiu'=>-12067,'xu'=>-12058,'xuan'=>-12039,'xue'=>-11867,'xun'=>-11861,
    'ya'=>-11847,'yan'=>-11831,'yang'=>-11798,'yao'=>-11781,'ye'=>-11604,'yi'=>-11589,'yin'=>-11536,'ying'=>-11358,'yo'=>-11340,'yong'=>-11339,'you'=>-11324,'yu'=>-11303,'yuan'=>-11097,'yue'=>-11077,'yun'=>-11067,
    'za'=>-11055,'zai'=>-11052,'zan'=>-11045,'zang'=>-11041,'zao'=>-11038,'ze'=>-11024,'zei'=>-11020,'zen'=>-11019,'zeng'=>-11018,'zha'=>-11014,'zhai'=>-10838,'zhan'=>-10832,'zhang'=>-10815,'zhao'=>-10800,'zhe'=>-10790,'zhen'=>-10780,'zheng'=>-10764,'zhi'=>-10587,'zhong'=>-10544,'zhou'=>-10533,'zhu'=>-10519,'zhua'=>-10331,'zhuai'=>-10329,'zhuan'=>-10328,'zhuang'=>-10322,'zhui'=>-10315,'zhun'=>-10309,'zhuo'=>-10307,'zi'=>-10296,'zong'=>-10281,'zou'=>-10274,'zu'=>-10270,'zuan'=>-10262,
'zui'=>-10260,'zun'=>-10256,'zuo'=>-10254
    );
    
    
    /**
     *+---------------------------------------------------------------------------------
     *    获取全部拼音
     *+---------------------------------------------------------------------------------
     *    @return string 
     *+---------------------------------------------------------------------------------
     */
    public function getAllPY($chinese, $delimiter = '', $length = 0,$charset='utf-8') {
        if($charset != 'gb2312') $chinese = $this->_U2_Utf8_Gb($chinese);
       $py = $this->zh_to_pys($chinese, $delimiter);
       if($length) {
           $py = substr($py, 0, $length);
       }
       return $py;
    }
    
    /**
     *+--------------------------------------------------------------------------------
     *    获取拼音首字母
     *+--------------------------------------------------------------------------------
     *    @return string
     *+--------------------------------------------------------------------------------
     */
    public function getFirstPY($chinese,$charset='utf-8'){
      if($charset != 'gb2312') $chinese = $this->_U2_Utf8_Gb($chinese);
       $result = '' ;
       for ($i=0; $i<strlen($chinese); $i++) {
           $p = ord(substr($chinese,$i,1));
           if ($p>160) {
              $q = ord(substr($chinese,++$i,1));
              $p = $p*256 + $q - 65536;
           }
           $result .= substr($this->zh_to_py($p),0,1);
       }
       return $result ;
    }
  
      public function _U2_Utf8_Gb($_C){
            $_String = '';
            if($_C < 0x80) $_String .= $_C;
            elseif($_C < 0x800)
            {
            $_String .= chr(0xC0 | $_C>>6);
            $_String .= chr(0x80 | $_C & 0x3F);
            }elseif($_C < 0x10000){
            $_String .= chr(0xE0 | $_C>>12);
            $_String .= chr(0x80 | $_C>>6 & 0x3F);
            $_String .= chr(0x80 | $_C & 0x3F);
            } elseif($_C < 0x200000) {
            $_String .= chr(0xF0 | $_C>>18);
            $_String .= chr(0x80 | $_C>>12 & 0x3F);
            $_String .= chr(0x80 | $_C>>6 & 0x3F);
            $_String .= chr(0x80 | $_C & 0x3F);
            }
            return iconv('UTF-8', 'GB2312', $_String);
    }
 
    private function zh_to_py($num, $blank = '') {
       if($num>0 && $num<160 ) {
           return chr($num);
       } elseif ($num<-20319||$num>-10247) {
           return $blank;
       } else {
           foreach ($this->pylist as $py => $code) {
              if($code > $num) break;
              $result = $py;
           }
           return $result;
       }
    }
      
    private function zh_to_pys($chinese, $delimiter = ' ', $first=0){
       $result = array();
       for($i=0; $i<strlen($chinese); $i++) {
           $p = ord(substr($chinese,$i,1));
           if($p>160) {
              $q = ord(substr($chinese,++$i,1));
              $p = $p*256 + $q - 65536;
           }
           $result[] = $this->zh_to_py($p);
           if ($first) {
              return $result[0];
           }
       }
       return implode($delimiter, $result);
    }
}